如何利用SQL Server 2005分布式分区视图分解数据表

ServerA:

CREATE VIEW dpv_SalesHistory

AS
      SELECT 
            SaleID, Product, Region, SaleDate, SalePrice
      FROM SalesDB.dbo.SalesHistory
      UNION ALL
      SELECT 
            SaleID, Product, Region, SaleDate, SalePrice
      FROM ServerB.SalesDB.dbo.SalesHistory



ServerB:

CREATE VIEW dpv_SalesHistory

AS
      SELECT 
            SaleID, Product, Region, SaleDate, SalePrice
      FROM SalesDB.dbo.SalesHistory
      UNION ALL
      SELECT 
            SaleID, Product, Region, SaleDate, SalePrice
      FROM ServerA.SalesDB.dbo.SalesHistory